﻿<%@ Page Language="C#" MasterPageFile="~/Admin/MasterPage.master" AutoEventWireup="true" CodeFile="ViewHFPropertyDetails.aspx.cs" Inherits="Admin_home_refinance_ViewHFPropertyDetails" Title="Home Loan - Property Details" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<div class="contentsfull">
    <table width="100%" cellpadding="3" cellspacing="0" border="0">
        <tr>
            <td>
                <h1>Home Loan Property Details</h1>
            </td>
        </tr>
        <tr>
            <td>
                <asp:DetailsView ID="dvPropertyDetails" runat="server" AutoGenerateRows="False" 
                    CellPadding="3" DataKeyNames="HFPropertyID" DataSourceID="sqlDsPropertyDetails" BorderStyle="Solid" BorderColor="#eff7fa" BorderWidth="1px"
                    EmptyDataText="No data." ForeColor="#333333" GridLines="None" CellSpacing="1" Width="100%">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
                    <RowStyle BackColor="#fbfeff" ForeColor="#333333" />
                    <FieldHeaderStyle BackColor="#eff7fa" Font-Bold="True" Width="200px" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <Fields>
                        <asp:BoundField DataField="HFPropertyID" HeaderText="HFPropertyID" 
                            InsertVisible="False" ReadOnly="True" SortExpression="HFPropertyID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFID" HeaderText="HFID" SortExpression="HFID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFPersonnelID" HeaderText="HFPersonnelID" 
                            SortExpression="HFPersonnelID" Visible="False" />
                        <asp:BoundField DataField="HFPropertyPrice" HeaderText="HFPropertyPrice" 
                            SortExpression="HFPropertyPrice" />
                        <asp:BoundField DataField="HFPurchaseDate" HeaderText="HFPurchaseDate" 
                            SortExpression="HFPurchaseDate" />
                        <asp:BoundField DataField="HFPostCode" HeaderText="HFPostCode" 
                            SortExpression="HFPostCode" />
                        <asp:BoundField DataField="HFBHNo" HeaderText="HFBHNo" 
                            SortExpression="HFBHNo" />
                        <asp:BoundField DataField="HFHomeNo" HeaderText="HFHomeNo" 
                            SortExpression="HFHomeNo" />
                        <asp:BoundField DataField="HFStreetName" HeaderText="HFStreetName" 
                            SortExpression="HFStreetName" />
                        <asp:BoundField DataField="HFPropertyType" HeaderText="HFPropertyType" 
                            SortExpression="HFPropertyType" />
                        <asp:BoundField DataField="HFForWhat" HeaderText="HFForWhat" 
                            SortExpression="HFForWhat" />
                        <asp:BoundField DataField="HFExpRentalAmount" HeaderText="HFExpRentalAmount" 
                            SortExpression="HFExpRentalAmount" />
                        <asp:BoundField DataField="HFCompleteStatus" HeaderText="HFCompleteStatus" 
                            SortExpression="HFCompleteStatus" />
                        <asp:BoundField DataField="HFTOPDate" HeaderText="HFTOPDate" 
                            SortExpression="HFTOPDate" />
                        <asp:BoundField DataField="HFLeasePropertyType" 
                            HeaderText="HFLeasePropertyType" SortExpression="HFLeasePropertyType" />
                        <asp:BoundField DataField="HFLeaseHold" HeaderText="HFLeaseHold" 
                            SortExpression="HFLeaseHold" />
                        <asp:CheckBoxField DataField="HFIsRenovate" HeaderText="HFIsRenovate" 
                            SortExpression="HFIsRenovate" />
                        <asp:BoundField DataField="HFRenovateAmount" HeaderText="HFRenovateAmount" 
                            SortExpression="HFRenovateAmount" />
                        <asp:CheckBoxField DataField="HFIsLanded" HeaderText="HFIsLanded" 
                            SortExpression="HFIsLanded" />
                        <asp:BoundField DataField="HFLandArea" HeaderText="HFLandArea" 
                            SortExpression="HFLandArea" />
                        <asp:BoundField DataField="HFLandAreaUnit" HeaderText="HFLandAreaUnit" 
                            SortExpression="HFLandAreaUnit" />
                        <asp:BoundField DataField="HFBuiltArea" HeaderText="HFBuiltArea" 
                            SortExpression="HFBuiltArea" Visible="False" />
                        <asp:BoundField DataField="HFBuiltAreaUnit" HeaderText="HFBuiltAreaUnit" 
                            SortExpression="HFBuiltAreaUnit" Visible="False" />
                        <asp:CheckBoxField DataField="Status" HeaderText="Status" 
                            SortExpression="Status" Visible="False" />
                        <asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" 
                            SortExpression="CreatedDate" Visible="False" />
                        <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" 
                            SortExpression="ModifiedDate" Visible="False" />
                    </Fields>
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#999999" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                </asp:DetailsView>
                <asp:SqlDataSource ID="sqlDsPropertyDetails" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>" 
                    SelectCommand="sprocHFPropertySelectSingleItemView" 
                    SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="HFID" QueryStringField="HFID" Type="Int64" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
        <tr>
            <td>
                <h1>Prefer Loan Information</h1>
            </td>
        </tr>
        <tr>
            <td>
                <asp:DetailsView ID="dvPreferLoanDetails" runat="server" 
                    AutoGenerateRows="False" CellPadding="3" DataKeyNames="HFLoanID" 
                    DataSourceID="sqlDsPreferLoanDetails" EmptyDataText="No data." BorderStyle="Solid" BorderColor="#eff7fa" BorderWidth="1px"
                    ForeColor="#333333" GridLines="None" CellSpacing="1" Width="100%">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <CommandRowStyle BackColor="#E2DED6" Font-Bold="True" />
                    <RowStyle BackColor="#fbfeff" ForeColor="#333333" />
                    <FieldHeaderStyle BackColor="#eff7fa" Font-Bold="True" Width="200px" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <EmptyDataTemplate>
                        No data.
                    </EmptyDataTemplate>
                    <Fields>
                        <asp:BoundField DataField="HFLoanID" HeaderText="HFLoanID" 
                            InsertVisible="False" ReadOnly="True" SortExpression="HFLoanID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFID" HeaderText="HFID" SortExpression="HFID" 
                            Visible="False" />
                        <asp:BoundField DataField="HFPersonnelID" HeaderText="HFPersonnelID" 
                            SortExpression="HFPersonnelID" Visible="False" />
                        <asp:BoundField DataField="HFFinNature" HeaderText="HFFinNature" 
                            SortExpression="HFFinNature" />
                        <asp:BoundField DataField="HFFinIns" HeaderText="HFFinIns" 
                            SortExpression="HFFinIns" />
                        <asp:BoundField DataField="HFFinMargin" HeaderText="HFFinMargin" 
                            SortExpression="HFFinMargin" />
                        <asp:BoundField DataField="HFLoanTenure" HeaderText="HFLoanTenure" 
                            SortExpression="HFLoanTenure" />
                        <asp:BoundField DataField="HFPurchaseDate" HeaderText="HFPurchaseDate" 
                            SortExpression="HFPurchaseDate" />
                        <asp:BoundField DataField="HFCurrentBank" HeaderText="HFCurrentBank" 
                            SortExpression="HFCurrentBank" />
                        <asp:BoundField DataField="HFOutLoanAmount" HeaderText="HFOutLoanAmount" 
                            SortExpression="HFOutLoanAmount" />
                        <asp:CheckBoxField DataField="HFPurchaseMortage" HeaderText="HFPurchaseMortage" 
                            SortExpression="HFPurchaseMortage" />
                        <asp:CheckBoxField DataField="HFCPFMonthRepay" HeaderText="HFCPFMonthRepay" 
                            SortExpression="HFCPFMonthRepay" />
                        <asp:BoundField DataField="HFCPFMonthRepayAmount" 
                            HeaderText="HFCPFMonthRepayAmount" SortExpression="HFCPFMonthRepayAmount" />
                        <asp:CheckBoxField DataField="HFCPFSLFee" HeaderText="HFCPFSLFee" 
                            SortExpression="HFCPFSLFee" />
                        <asp:BoundField DataField="HFCPFSLFeeAmount" HeaderText="HFCPFSLFeeAmount" 
                            SortExpression="HFCPFSLFeeAmount" />
                        <asp:CheckBoxField DataField="HFIsUseCPF" HeaderText="HFIsUseCPF" 
                            SortExpression="HFIsUseCPF" />
                        <asp:CheckBoxField DataField="Status" HeaderText="Status" 
                            SortExpression="Status" Visible="False" />
                        <asp:BoundField DataField="CreatedDate" HeaderText="CreatedDate" 
                            SortExpression="CreatedDate" Visible="False" />
                        <asp:BoundField DataField="ModifiedDate" HeaderText="ModifiedDate" 
                            SortExpression="ModifiedDate" Visible="False" />
                    </Fields>
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <EditRowStyle BackColor="#999999" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                </asp:DetailsView>
                <asp:SqlDataSource ID="sqlDsPreferLoanDetails" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:CX_DBConnectionString %>" 
                    SelectCommand="sprocHFPreferLoanSelectSingleItemView" 
                    SelectCommandType="StoredProcedure">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="HFID" QueryStringField="HFID" Type="Int64" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </td>
        </tr>
    </table>
</div>
</asp:Content>

